insert overwrite table jms_tmp.dwd_yl_oms_oms_waybill_last_hour_status_check partition (dt)
select waybill_no
     , from_unixtime(unix_timestamp(), 'yyyy-MM-dd HH:mm:ss') as update_time
     , '{{ execution_date | cst_ds }}'                        as dt
from jms_dwd.dwd_yl_oms_oms_waybill_last_hour_status
where dt = '{{ execution_date | cst_ds }}'
  and waybill_no is not null
limit 1
;
